2015F CST8276 QUIZ 2 VERSION 1

1. Oracle 12c uses ____ in its implementation of ILM.
	a. data tracking using a heat lamp
	b. partitioning
	c. maintenance automation
	d. compression
	e. All of the above (correct)

2. Oracle's Automatic Data Optimization (DAO) _____.
	a. Tracks data using a heat map (correct)
	b. Must be used with partitioned tables
	c. Tracks data using an ADO encrypted tracking device
	d. Uses the initialization parameter ADO_mangement
	e. All of the above

3. Oracle's Temporal Validity ____.
	a. Allows the addition of one or more valid time dimensions to each row of a table
	b. Allows rows to be visible or not based on time-based validity
	c. Is determined by valid dates or timestamps
	d. Allows data in the same table to be identified as active or non-active
	e. All of the above (correct)

4. Ensuring regulatory compliance requires collaborative effort between ____.
	a. Business and legal groups
	b. Legal and IT groups
	c. Business and IT groups
	d. Business, Legal and IT groups (correct)
	e. None of the above

5. What is PII?
	a. Personally identifiable information
	b. Any data element used to identify an individual
	c. A data element deserving privacy consideration
	d. None of the above (correct?)
	e. All of the above

6. What is the purpose of data masking?
	a. Protecting sensitive information from inappropriate visibility (correct)
	b. Grey out fields which cannot be changed
	c. Create a web page with data from multiple masked sources
	d. Mask sources of information for use in data warehouses
	e. All of the above

7. When a distributed database create copies of the database on different servers, this is known as:
	a. replication (correct)
	b. partitioning
	c. disbursing
	d. distributed tow-phase locking
	e. none of the above

8. _____ is a characteristic where each server participating in a distributed database is administered independently from all other databases.
	a. isolation
	b. transparency
	c. autonomy (correct)
	d. accessibility
	e. atomicity

9. What is the biggest threat to efficient performance for a distributed database system?
	a. Globalization issues
	b. Network traffic (correct)
	c. Heterogeneous DBMSs
	d. Data warehouses
	e. Homogeneous DBMSs

10. What software assists Oracle in moving or copying data?
	a. Oracle Data Pump
	b. Oracle SQL*Loader
	c. Oracle Export
	d. Oracle Import
	e. all of the above (correct)

11. An Oracle 12c enhancement to Data Pump is ____.
	a. exporting data
	b. importing data
	c. moving data between test and production databases
	d. fully transportable export and import (correct)
	e. SQL *Loader Express

12. The main advantage of monolingual databases is ____.
	a. fast backup
	b. fast recovery
	c. less effort and complexity for DBA
	d. less chance of error
	e. fast response time (correct)

13. IF NLS_Date_Format = DD-MON-RR the rules governing the year are ____.
	a. all inserts dates will have only a 2 digit year
	b. you can store 20th century dates in the 21st century with only 2 digits (correct)
	c. all 20th century dates will have 21st century years
	d. all 21st century years will have 22nd century years
	e. the current year will be attached to the date

14. How is National language supported by Oracle?
	a. server side initialization parameters
	b. client side environment variables
	c. client side session parameters
	d. SQL functions
	e. all of the above (correct)

15. Which of the following National language supporting parameters takes highest precedence and will override the others?
	a. server side initialization parameters
	b. client side environment variables
	c. client side session parameters
	d. server side environment variables
	e. parameter used in an SQL function (correct)

16. Which of the following segment types stores data from more than one table, to group data from related tables?
	a. table segment
	b. cluster (correct)
	c. index partition
	d. LOB
	e. CLOB

17. What type of table partitioning is valid in an Oracle database?
	a. range
	b. list
	c. hash
	d. range-List
	e. all of the above (correct)

18. A data warehouse database differs from an operational database because:
	a. Data warehouse data are not stored in tables
	b. Data warehouse databases do not have metadata
	c. Data warehouse data are often denormalized (correct)
	d. b and c
	e. a, b and c

19. Star schemas have a _____ at the center of the star.
	a. fact table (correct)
	b. dimension table
	c. map table
	d. reduce table
	e. none of the above

20. Data mining is best used for ____.
	a. providing summary data
	b. supporting rapid response
	c. predicting/discovering data (correct)
	d. using multiple dimensions
	e. all of the above